Dependency-preserving normalization of relational and XML data
نویسندگان
چکیده
منابع مشابه
Dependency-Preserving Normalization of Relational and XML Data (Appendix)
(⇒) Suppose (R, Σ) is in 3NF and I ∈ inst(R, Σ). Having INFI(p|Σ) < 1 for some p = (R, t, A) in Pos(I) means that there is redundant information in position p. Since we assume Σ only contains FDs, there must be an FD X → A ∈ Σ and a different tuple t in I, such that t[X] = t[X] and therefore t[A] = t[A]. This can only happen when X is not a key. Thus, A is a prime attribute. (⇐) Assume that the...
متن کاملDependency-Preserving Normalization of Relational and XML Data
Motivation Schema design: coming up with a " good " way of grouping the attributes of interest to avoid insertion, update, and deletion anomalies. 3NF: does not eliminate all redundancies, preserves all dependencies.
متن کاملd - Dependency for privacy - preserving XML data publishing
http://dx.doi.org/10.1016/j.jbi.2014.01.013 1532-0464/ 2014 Published by Elsevier Inc. ⇑ Corresponding author. E-mail addresses: [email protected] (A.H. Landberg), kinh.nguyen@ latrobe.edu.au (K. Nguyen), [email protected] (E. Pardede), w.rahayu@ latrobe.edu.au (J.W. Rahayu). URLs: http://www.latrobe.edu.au/scitecheng/about/staff/profile?uname= K2Nguyen (K. Nguyen), http://home...
متن کاملPreserving and Querying Histories of XML-Published Relational Databases
There is much current interest in publishing and viewing database-resident data as XML documents. In fact, such XML views of the database can be easily visualized on web browsers and processed by web languages, including powerful query languages such as XQuery. As the database is updated, its external XML view also evolves. In this paper, we investigate the problem of representing the evolution...
متن کاملXML Structures for Relational Data
XML is increasingly being adopted for information publishing on the World Wide Web. However, the underlying data is often stored in the relational databases. Some mechanism is needed to convert the relational data into XML data. In this work, we employ a semantically rich semistructured data model, the Object-RelationshipAttribute model for semistructured data, as a middleware to support the sc...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Journal of Computer and System Sciences
سال: 2007
ISSN: 0022-0000
DOI: 10.1016/j.jcss.2006.10.014